# -*- coding:utf-8 -*-
from dao.MySqlDAL import MySqlDAL
__author__ = 'shudongma.msd(风骐)'

sqlUtil = MySqlDAL()
res = sqlUtil.get_dimensions_rows('select stock_id,stock_name from tb_stock_info')
stocks_name = []
stocks_id = []
stocks_id_without_head = []
stocks_head_dict = {}
for row in res:
    stocks_name.append (row['stock_name'])
    stocks_id.append(row['stock_id'])
    stocks_id_without_head.append(str(row['stock_id'])[2:])
    stocks_head_dict[str(row['stock_id'])[2:]] = row['stock_id']